﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="QueryReport.aspx.cs" Inherits="Admin_UserManagement_QueryReport" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>查询、导出预约表</title>

<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
		<meta content="C#" name="CODE_LANGUAGE">
		<meta content="JavaScript" name="vs_defaultClientScript">
		<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
		<LINK href="../Admin.css" type="text/css" rel="stylesheet">
		<script type="text/javascript" src="../setday/JScript.js"></script>
	</HEAD>
	<BODY>

		<form id="Form1" method="post" runat="server">
			<table class="tableBorder" id="table2" height="127" cellSpacing="1" cellPadding="3" align="center"
				border="0">
				<tr>
					<th id="tabletitlelink" style="FONT-WEIGHT: bold; FONT-SIZE: 12px; BACKGROUND-IMAGE: url(images/admin_bg_1.gif); COLOR: white; BACKGROUND-COLOR: #4455aa"
						align="left" height="25">
						<p align="center" style ="font-size :20px;">查询、导出预约表</p>
					</th>
				</tr>
				<tr>
					<th id="Th1" style="FONT-WEIGHT: bold; FONT-SIZE: 12px; BACKGROUND-IMAGE: url(images/admin_bg_1.gif); COLOR: white; BACKGROUND-COLOR: #4455aa"
						align="left" height="25">
					&nbsp;体检机构:&nbsp;	
                        <%--<asp:DropDownList ID="DropDownList1" runat="server">
                        <asp:ListItem Selected="True" Value=" ">全部</asp:ListItem>
                            <asp:ListItem>瑞慈体检-静安店</asp:ListItem>
                            <asp:ListItem>瑞慈体检-陆家嘴分部</asp:ListItem>
                        </asp:DropDownList>--%>
                        
                        <asp:DropDownList ID="ddljigou" runat="server" AutoPostBack="True"   onselectedindexchanged="ddljigou_SelectedIndexChanged"
                            DataTextField="name" DataValueField="id" >
                            <asp:ListItem></asp:ListItem>
                         </asp:DropDownList> 
                        &nbsp;&nbsp;&nbsp;&nbsp;
									&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                        <asp:RadioButton ID="RadioButton1" runat="server" Text="当天" Checked="true" 
                            GroupName="1" AutoPostBack="True" 
                            oncheckedchanged="RadioButton1_CheckedChanged"/>
&nbsp; 
                        <asp:RadioButton ID="RadioButton2" runat="server" GroupName="1" Text="日期" 
                            AutoPostBack="True" oncheckedchanged="RadioButton2_CheckedChanged"/>
                    &nbsp;
                                            <asp:DropDownList ID="DropDownList2" runat="server" 
                            AutoPostBack="True" Enabled="False">
                                                <asp:ListItem  Selected="True">2011-07-17</asp:ListItem>
                                                <asp:ListItem>2011-07-18</asp:ListItem>
                                                <asp:ListItem>2011-07-19</asp:ListItem>
                                                <asp:ListItem>2011-07-20</asp:ListItem>
                                                <asp:ListItem>2011-07-21</asp:ListItem>
                                                <asp:ListItem>2011-07-22</asp:ListItem>
                                                <asp:ListItem>2011-07-23</asp:ListItem>
                                                <asp:ListItem>2011-07-24</asp:ListItem>
                                                <asp:ListItem>2011-07-25</asp:ListItem>
                                                <asp:ListItem>2011-07-26</asp:ListItem>
                                                <asp:ListItem>2011-07-27</asp:ListItem>
                                                <asp:ListItem>2011-07-28</asp:ListItem>
                                                <asp:ListItem>2011-07-29</asp:ListItem>
                                                <asp:ListItem>2011-07-30</asp:ListItem>
                                                <asp:ListItem>2011-07-31</asp:ListItem>
                                                <asp:ListItem>2011-08-01</asp:ListItem>
                                                <asp:ListItem>2011-08-02</asp:ListItem>
                                                <asp:ListItem>2011-08-03</asp:ListItem>
                                                <asp:ListItem>2011-08-04</asp:ListItem>
                                                <asp:ListItem>2011-08-05</asp:ListItem>
                                                <asp:ListItem>2011-08-06</asp:ListItem>
                                                <asp:ListItem>2011-08-07</asp:ListItem>
                                                <asp:ListItem>2011-08-08</asp:ListItem>
                                                <asp:ListItem>2011-08-09</asp:ListItem>
                                                <asp:ListItem>2011-08-10</asp:ListItem>
                                                <asp:ListItem>2011-08-11</asp:ListItem>
                                                <asp:ListItem>2011-08-12</asp:ListItem>
                                                <asp:ListItem>2011-08-13</asp:ListItem>
                                                <asp:ListItem>2011-08-14</asp:ListItem>
                                                <asp:ListItem>2011-08-15</asp:ListItem>
                                            </asp:DropDownList>
                    &nbsp;&nbsp;至&nbsp;<asp:DropDownList ID="DropDownList3" runat="server" 
                            AutoPostBack="True" Enabled="False">
                                                <asp:ListItem  Selected="True">2011-07-17</asp:ListItem>
                                                <asp:ListItem>2011-07-18</asp:ListItem>
                                                <asp:ListItem>2011-07-19</asp:ListItem>
                                                <asp:ListItem>2011-07-20</asp:ListItem>
                                                <asp:ListItem>2011-07-21</asp:ListItem>
                                                <asp:ListItem>2011-07-22</asp:ListItem>
                                                <asp:ListItem>2011-07-23</asp:ListItem>
                                                <asp:ListItem>2011-07-24</asp:ListItem>
                                                <asp:ListItem>2011-07-25</asp:ListItem>
                                                <asp:ListItem>2011-07-26</asp:ListItem>
                                                <asp:ListItem>2011-07-27</asp:ListItem>
                                                <asp:ListItem>2011-07-28</asp:ListItem>
                                                <asp:ListItem>2011-07-29</asp:ListItem>
                                                <asp:ListItem>2011-07-30</asp:ListItem>
                                                <asp:ListItem>2011-07-31</asp:ListItem>
                                                <asp:ListItem>2011-08-01</asp:ListItem>
                                                <asp:ListItem>2011-08-02</asp:ListItem>
                                                <asp:ListItem>2011-08-03</asp:ListItem>
                                                <asp:ListItem>2011-08-04</asp:ListItem>
                                                <asp:ListItem>2011-08-05</asp:ListItem>
                                                <asp:ListItem>2011-08-06</asp:ListItem>
                                                <asp:ListItem>2011-08-07</asp:ListItem>
                                                <asp:ListItem>2011-08-08</asp:ListItem>
                                                <asp:ListItem>2011-08-09</asp:ListItem>
                                                <asp:ListItem>2011-08-10</asp:ListItem>
                                                <asp:ListItem>2011-08-11</asp:ListItem>
                                                <asp:ListItem>2011-08-12</asp:ListItem>
                                                <asp:ListItem>2011-08-13</asp:ListItem>
                                                <asp:ListItem>2011-08-14</asp:ListItem>
                                                <asp:ListItem>2011-08-15</asp:ListItem>
                                            </asp:DropDownList>
                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									<asp:button id="btnsearch" runat="server" Text="查找" OnClick="btnsearch_Click" Width="70px"></asp:button>
                    </th>
				</tr>
				<tr>
					<td class="forumRowHighlight" style="height: 12px">&nbsp;
					<table class="tableBorder" id="table1"  border="0"
					style="WIDTH: 100%">
		
					    <TR>
					    <TD class="Forumrow" align="center" width="10%" style="height: 25px"><STRONG>工号</STRONG></TD>
						<TD class="Forumrow" align="center" width="5%" style="height: 25px"><STRONG>姓名</STRONG></TD>
						<TD class="Forumrow" width="5%" align="center"  style="height: 25px"><STRONG>性别</STRONG></TD>						
					    <TD class="Forumrow" align="center" width="5%" style="height: 25px"><STRONG>年龄</STRONG></TD>
					    <TD class="Forumrow" align="center" width="5%" style="height: 25px"><STRONG>婚否</STRONG></TD>
					    <TD class="Forumrow" align="center" width="6%" style="height: 25px"><STRONG>手机</STRONG></TD>
					    <TD class="Forumrow" align="center" width="10%" style="height: 25px"><STRONG>身份证号</STRONG></TD>
					    <TD class="Forumrow" align="center" width="6%" style="height: 25px"><STRONG>体检套餐</STRONG></TD>
						<TD class="Forumrow" align="center" width="10%" style="height: 25px"><STRONG>体检机构</STRONG></TD>
					    <TD class="Forumrow" align="center" width="10%" style="height: 25px"><STRONG>体检时间</STRONG></TD>
					    <TD class="Forumrow" align="center" width="6%" style="height: 25px"><STRONG>是否家属</STRONG></TD>
					    <TD class="Forumrow" align="center" width="5%" style="height: 25px"><STRONG>是否VIP</STRONG></TD>
					    <TD class="Forumrow" align="center" width="8%" style="height: 25px"><STRONG>体检状态</STRONG></TD>
					</TR>

					    
                            <asp:Repeater ID="Repeater1" runat="server">
                            <ItemTemplate>
							<tr>
							    <td class="Forumrow" width="10%" height="25" align="center"><%#Eval("UserLogin")%></td>
							    <td class="Forumrow" width="5%" height="25" align="center"><%#Eval("UserName")%></td>
								<td class="Forumrow" width="5%" align="center" height="25"><%#Eval("UserSex")%></td>
								<td class="Forumrow" width="5%" align="center"><%#Eval("UserAge")%></td>
							    <td class="Forumrow" width="5%" align="center"><%#Eval("Marriage")%></td>
							    <td class="Forumrow" width="6%" align="center"><%#Eval("HandsetNumber")%></td>
							    <td class="Forumrow" width="10%" align="center"><%#Eval("UserIDCard")%></td>
							    <td class="Forumrow" width="6%" align="center"><%#Eval("SetMeal")%></td>
								<TD class="Forumrow" align="center" width="10%"><%#Eval("AgencyName")%></TD>
					            <TD class="Forumrow" align="center" width="10%"><%#Eval("ReservationTime","{0:yyyy-MM-dd}")%></TD>
					            <td class="Forumrow" width="6%" align="center"><%#Eval("whetherUser")%></td>
					            <td class="Forumrow" width="5%" align="center"><%#Eval("whetherVIP").ToString()=="0"?"否":"是"%></td>
					            <TD class="Forumrow" align="center" width="8%"><%#getAgency(Eval("userid").ToString())%></TD>
							</tr>
					</ItemTemplate></asp:Repeater>
					</table>
					
                    </td></tr>
                    <tr><td align="center" style="height: 27px">
                    <webdiyer:aspnetpager id="AspNetPager1" runat="server" horizontalalign="Center" onpagechanged="AspNetPager1_PageChanged"
        showcustominfosection="Left" width="95%" meta:resourceKey="AspNetPager1" style="font-size:14px" InputBoxStyle="width:19px"
        CustomInfoHTML="共有<b><font color='red'>%RecordCount%</font></b>条记录 当前页<font color='red'><b>%CurrentPageIndex%/%PageCount%</b></font>   次序 %StartRecordIndex%-%EndRecordIndex%" AlwaysShow="True" FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PrevPageText="上一页" CustomInfoStyle="FONT-SIZE: 12px"></webdiyer:aspnetpager>
                    </td></tr>
                    
				
					<TR>
						<TD class="forumRowHighlight" height="12" align="right">
                            &nbsp;&nbsp;
                            <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="打印报表" 
                                Width="90px" />
                            &nbsp;&nbsp;
							&nbsp;&nbsp;
						</table>
		</form>
	</BODY>
</HTML>
